﻿CREATE TABLE [dbo].[SiteCollection] (
    [SiteCollectionID]   UNIQUEIDENTIFIER NOT NULL,
    [WebApplicationID]   UNIQUEIDENTIFIER NOT NULL,
    [UpgradeRedirectUri] VARCHAR (200)    NULL,
    [ContentDatabaseID]  UNIQUEIDENTIFIER NULL,
    [Size]               FLOAT (53)       NULL,
    CONSTRAINT [PK_SiteCollection] PRIMARY KEY CLUSTERED ([SiteCollectionID] ASC),
    CONSTRAINT [FK_SiteCollection_WebApplication] FOREIGN KEY ([WebApplicationID]) REFERENCES [dbo].[WebApplication] ([WebApplicationID])
);

